﻿if exists (select * from dbo.sysobjects where name = 'sp_tblDiscount_Update')
	drop procedure [dbo].[sp_tblDiscount_Update]
Go 
CREATE PROCEDURE dbo.sp_tblDiscount_Update
@_did	int,
@_sid	int,
@_drate	float
AS
UPDATE tblDiscount SET [_sid] = @_sid,[_drate] = @_drate
WHERE  _did= @_did
Go